package com.ruoyi.job.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.core.domain.business.waterManagement.WrStatvolD;
import com.ruoyi.common.core.domain.business.waterManagement.WrStatvolM;
import com.ruoyi.common.core.domain.business.waterManagement.WrStatvolY;
import org.apache.ibatis.annotations.Param;


import java.util.List;


/**
 * 测站日水量Mapper接口
 * 
 * @author hwd
 * @date 2023-02-20
 */
public interface WrStatvolDMapper  extends BaseMapper<WrStatvolD>
{
    /**
     * 查询测站日水量
     * 
     * @param statCd 测站日水量主键
     * @return 测站日水量
     */
    public WrStatvolD selectWrStatvolDByStatCd(String statCd);

    /**
     * 查询测站日水量列表
     * 
     * @param wrStatvolD 测站日水量
     * @return 测站日水量集合
     */
    public List<WrStatvolD> selectWrStatvolDList(WrStatvolD wrStatvolD);

    /**
     * 新增测站日水量
     * 
     * @param wrStatvolD 测站日水量
     * @return 结果
     */
    public int insertWrStatvolD(WrStatvolD wrStatvolD);

    /**
     * 修改测站日水量
     * 
     * @param wrStatvolD 测站日水量
     * @return 结果
     */
    public int updateWrStatvolD(WrStatvolD wrStatvolD);

    /**
     * 删除测站日水量
     * 
     * @param statCd 测站日水量主键
     * @return 结果
     */
    public int deleteWrStatvolDByStatCd(String statCd);

    /**
     * 批量删除测站日水量
     * 
     * @param statCds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteWrStatvolDByStatCds(String[] statCds);

    /**
     * 按日统计月水量数据
     * @param
     * @return
     */
    WrStatvolD countMonthByWrStatvolD(@Param("statCd")String statCd, @Param("yy") String yy, @Param("mm") String mm);

    /**
     * 插入或更新日水量
     * @param wrStatvolD
     */
    void insertOrUpdateWrStatvolD(WrStatvolD wrStatvolD);

    /**
     * 按日统计水管机构水量数据
     * @param
     * @return
     */
    WrStatvolD countWiOrgVolDByWrStatvolD(@Param("statCd")String statCd, @Param("yy") String yy,@Param("mm") String mm, @Param("dd") String dd);
}
